Pandas Profiling Report

Dataset statistics

Number of variables	28
Number of observations	26969
Missing cells	32
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.8 MiB
Average record size in memory	224.0 B

Variable types

CAT	16
NUM	10
BOOL	2

Reproduction

Analysis started	2020-09-21 17:00:31.509054
Analysis finished	2020-09-21 17:00:59.720593
Duration	28.21 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`df_index` has constant value "0"	Constant
`Date & Time` has a high cardinality: 22997 distinct values	High cardinality
`Type of aircraft` has a high cardinality: 1085 distinct values	High cardinality
`Operator` has a high cardinality: 7837 distinct values	High cardinality
`Registration` has a high cardinality: 25839 distinct values	High cardinality
`Schedule` has a high cardinality: 14646 distinct values	High cardinality
`MSN` has a high cardinality: 17759 distinct values	High cardinality
`Location` has a high cardinality: 12845 distinct values	High cardinality
`Country` has a high cardinality: 218 distinct values	High cardinality
`Circumstances` has a high cardinality: 21207 distinct values	High cardinality
`FlightDate` has a high cardinality: 17590 distinct values	High cardinality
`FlightOperator` has a high cardinality: 7836 distinct values	High cardinality
`src_rowid` is highly correlated with `rowid`	High correlation
`rowid` is highly correlated with `src_rowid`	High correlation
`Total fatalities` is highly correlated with `Pax fatalities`	High correlation
`Pax fatalities` is highly correlated with `Total fatalities`	High correlation
`Crew on board` is highly skewed (γ1 = 149.7973589)	Skewed
`Other fatalities` is highly skewed (γ1 = 61.95186755)	Skewed
`Date & Time` is uniformly distributed	Uniform
`Registration` is uniformly distributed	Uniform
`FlightDate` is uniformly distributed	Uniform
`rowid` has unique values	Unique
`src_rowid` has unique values	Unique
`dt` has unique values	Unique
`Crew on board` has 3480 (12.9%) zeros	Zeros
`Crew fatalities` has 13596 (50.4%) zeros	Zeros
`Pax on board` has 14091 (52.2%) zeros	Zeros
`Pax fatalities` has 20401 (75.6%) zeros	Zeros
`Other fatalities` has 26634 (98.8%) zeros	Zeros
`Total fatalities` has 11108 (41.2%) zeros	Zeros
`PlaneAge` has 1979 (7.3%) zeros	Zeros

rowid
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	26969
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13485.041232526233
Minimum	1
Maximum	26970
Zeros	0
Zeros (%)	0.0%
Memory size	210.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1349.4
Q1	6743
median	13485
Q3	20227
95-th percentile	25620.6
Maximum	26970
Range	26969
Interquartile range (IQR)	13484

Descriptive statistics

Standard deviation	7785.492517
Coefficient of variation (CV)	0.5773428781
Kurtosis	-1.199966116
Mean	13485.04123
Median Absolute Deviation (MAD)	6742
Skewness	2.795850132e-05
Sum	363678077
Variance	60613893.73

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2047	1	< 0.1%
7529	1	< 0.1%
3371	1	< 0.1%
13612	1	< 0.1%
15661	1	< 0.1%
9518	1	< 0.1%
11567	1	< 0.1%
21824	1	< 0.1%
23873	1	< 0.1%
17730	1	< 0.1%
Other values (26959)	26959	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
26970	1	< 0.1%
26969	1	< 0.1%
26968	1	< 0.1%
26967	1	< 0.1%
26966	1	< 0.1%

src_rowid
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	26969
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13485.041232526233
Minimum	1
Maximum	26970
Zeros	0
Zeros (%)	0.0%
Memory size	210.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1349.4
Q1	6743
median	13485
Q3	20227
95-th percentile	25620.6
Maximum	26970
Range	26969
Interquartile range (IQR)	13484

Descriptive statistics

Standard deviation	7785.492517
Coefficient of variation (CV)	0.5773428781
Kurtosis	-1.199966116
Mean	13485.04123
Median Absolute Deviation (MAD)	6742
Skewness	2.795850132e-05
Sum	363678077
Variance	60613893.73

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2047	1	< 0.1%
7529	1	< 0.1%
3371	1	< 0.1%
13612	1	< 0.1%
15661	1	< 0.1%
9518	1	< 0.1%
11567	1	< 0.1%
21824	1	< 0.1%
23873	1	< 0.1%
17730	1	< 0.1%
Other values (26959)	26959	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
26970	1	< 0.1%
26969	1	< 0.1%
26968	1	< 0.1%
26967	1	< 0.1%
26966	1	< 0.1%

dt
Categorical

UNIQUE

Distinct count	26969
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

2020-09-20 20:45:25.443000	1
2020-09-20 18:37:07.430000	1
2020-09-20 15:16:08.957000	1
2020-09-20 17:10:10.123000	1
2020-09-20 22:00:30.400000	1
Other values (26964)	26964

Common Values
Length

Value	Count	Frequency (%)
2020-09-20 20:45:25.443000	1	< 0.1%
2020-09-20 18:37:07.430000	1	< 0.1%
2020-09-20 15:16:08.957000	1	< 0.1%
2020-09-20 17:10:10.123000	1	< 0.1%
2020-09-20 22:00:30.400000	1	< 0.1%
2020-09-20 16:43:52.020000	1	< 0.1%
2020-09-20 19:34:38.747000	1	< 0.1%
2020-09-20 15:25:45.630000	1	< 0.1%
2020-09-20 19:12:37.950000	1	< 0.1%
2020-09-20 16:21:36.657000	1	< 0.1%
Other values (26959)	26959	> 99.9%

Length

Max length	26
Median length	26
Mean length	25.97041047
Min length	19

df_index
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

0	26969

Frequency Table

Value	Count	Frequency (%)
0	26969	100.0%

Date & Time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	22997
Unique (%)	85.3%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Mar 24, 1945	15
Mar 6, 1944	11
Jun 6, 1944	10
Dec 18, 1939	10
Dec 31, 1935	9
Other values (22992)	26914

Common Values
Length

Value	Count	Frequency (%)
Mar 24, 1945	15	0.1%
Mar 6, 1944	11	< 0.1%
Jun 6, 1944	10	< 0.1%
Dec 18, 1939	10	< 0.1%
Dec 31, 1935	9	< 0.1%
Sep 16, 1943	9	< 0.1%
Mar 24, 1944	8	< 0.1%
Apr 16, 1944	8	< 0.1%
Jul 11, 1943	8	< 0.1%
Jan 6, 1945	7	< 0.1%
Other values (22987)	26874	99.6%

Length

Max length	23
Median length	22
Mean length	17.28425229
Min length	11

Type of aircraft
Categorical

HIGH CARDINALITY

Distinct count	1085
Unique (%)	4.0%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Douglas C-47 Skytrain (DC-3)	2164
PZL-Mielec AN-2	761
Curtiss C-46 Commando	634
Avro 652 Anson	532
Douglas DC-3	423
Other values (1080)	22455

Common Values
Length

Value	Count	Frequency (%)
Douglas C-47 Skytrain (DC-3)	2164	8.0%
PZL-Mielec AN-2	761	2.8%
Curtiss C-46 Commando	634	2.4%
Avro 652 Anson	532	2.0%
Douglas DC-3	423	1.6%
De Havilland DH.60 Moth	357	1.3%
De Havilland DHC-2 Beaver	339	1.3%
Piper PA-31-350 Navajo Chieftain	333	1.2%
Britten-Norman Islander	328	1.2%
Lockheed C-130 Hercules	321	1.2%
Other values (1075)	20777	77.0%

Length

Max length	43
Median length	21
Mean length	20.37713671
Min length	4

Operator
Categorical

HIGH CARDINALITY

Distinct count	7837
Unique (%)	29.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Royal Air Force - RAF (31257)	2247
United States Air Force - USAF (since 1947) (31252)	1443
Aeroflot - Russian International Airlines (30808)	1358
United States Army Air Forces - USAAF (1941-1947) (39359)	1350
United States Navy - USN (37278)	651
Other values (7832)	19920

Common Values
Length

Value	Count	Frequency (%)
Royal Air Force - RAF (31257)	2247	8.3%
United States Air Force - USAF (since 1947) (31252)	1443	5.4%
Aeroflot - Russian International Airlines (30808)	1358	5.0%
United States Army Air Forces - USAAF (1941-1947) (39359)	1350	5.0%
United States Navy - USN (37278)	651	2.4%
Private American (31833)	403	1.5%
Royal Australian Air Force - RAAF (31800)	267	1.0%
French Air Force - Armée de l'Air (31256)	191	0.7%
Royal Canadian Air Force - RCAF (31234)	175	0.6%
Brazilian Air Force - Força Aérea Brasileira (31232)	164	0.6%
Other values (7827)	18720	69.4%

Length

Max length	98
Median length	32
Mean length	36.07504913
Min length	11

Registration
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	25839
Unique (%)	95.8%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

2	6
1	6
48	5
29	5
1H+?S	5
Other values (25834)	26942

Common Values
Length

Value	Count	Frequency (%)
2	6	< 0.1%
1	6	< 0.1%
48	5	< 0.1%
29	5	< 0.1%
1H+?S	5	< 0.1%
75	4	< 0.1%
26	4	< 0.1%
104	4	< 0.1%
7	4	< 0.1%
40	4	< 0.1%
Other values (25829)	26922	99.8%

Length

Max length	15
Median length	6
Mean length	6.217101116
Min length	1

Flight Phase
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Flight	10930
Landing (descent or approach)	9808
Takeoff (climb)	5898
Taxiing	229
Parking	104

Common Values
Length

Value	Count	Frequency (%)
Flight	10930	40.5%
Landing (descent or approach)	9808	36.4%
Takeoff (climb)	5898	21.9%
Taxiing	229	0.8%
Parking	104	0.4%

Length

Max length	29
Median length	15
Mean length	16.34517409
Min length	6

Flight Type
Categorical

Distinct count	31
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Scheduled Revenue Flight	6122
Military	4476
Training	3105
Cargo	2719
Private	1955
Other values (26)	8592

Common Values
Length

Value	Count	Frequency (%)
Scheduled Revenue Flight	6122	22.7%
Military	4476	16.6%
Training	3105	11.5%
Cargo	2719	10.1%
Private	1955	7.2%
Charter/Taxi (Non Scheduled Revenue Flight)	1594	5.9%
Executive	975	3.6%
Survey / Patrol / Reconnaissance	942	3.5%
Bombing	678	2.5%
Positioning	633	2.3%
Other values (21)	3770	14.0%

Length

Max length	43
Median length	8
Mean length	14.74233379
Min length	4

Survivors
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Yes	15275
No	11694

Frequency Table

Value	Count	Frequency (%)
Yes	15275	56.6%
No	11694	43.4%

Site
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Airport (less than 10 km from airport)	13136
Plain, Valley	6260
Lake, Sea, Ocean, River	3633
Mountains	3295
City	443

Common Values
Length

Value	Count	Frequency (%)
Airport (less than 10 km from airport)	13136	48.7%
Plain, Valley	6260	23.2%
Lake, Sea, Ocean, River	3633	13.5%
Mountains	3295	12.2%
City	443	1.6%
Desert	202	0.7%

Length

Max length	38
Median length	23
Mean length	25.8350699
Min length	4

Schedule
Categorical

HIGH CARDINALITY

Distinct count	14646
Unique (%)	54.3%
Missing	1
Missing (%)	< 0.1%
Memory size	210.7 KiB

Point Cook - Point Cook	49
Mildenhall - Mildenhall	47
Waddington - Waddington	47
Paris - Croydon	44
Scampton - Scampton	44
Other values (14641)	26737

Common Values
Length

Value	Count	Frequency (%)
Point Cook - Point Cook	49	0.2%
Mildenhall - Mildenhall	47	0.2%
Waddington - Waddington	47	0.2%
Paris - Croydon	44	0.2%
Scampton - Scampton	44	0.2%
Coningsby - Coningsby	43	0.2%
Silloth - Silloth	43	0.2%
Moscow - Moscow	35	0.1%
Swinderby - Swinderby	34	0.1%
Kinloss - Kinloss	32	0.1%
Other values (14636)	26550	98.4%

Length

Max length	244
Median length	20
Mean length	22.81423115
Min length	3

MSN
Categorical

HIGH CARDINALITY

Distinct count	17759
Unique (%)	65.8%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

01	67
2	51
1	50
10	40
14	38
Other values (17754)	26723

Common Values
Length

Value	Count	Frequency (%)
01	67	0.2%
2	51	0.2%
1	50	0.2%
10	40	0.1%
14	38	0.1%
3	37	0.1%
15	33	0.1%
6	28	0.1%
25	28	0.1%
4	26	0.1%
Other values (17749)	26571	98.5%

Length

Max length	17
Median length	5
Mean length	5.480588824
Min length	1

YOM
Real number (ℝ_≥0)

Distinct count	104
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1955.4122511031185
Minimum	1911
Maximum	2018
Zeros	0
Zeros (%)	0.0%
Memory size	210.7 KiB

Quantile statistics

Minimum	1911
5-th percentile	1928
Q1	1943
median	1951
Q3	1970
95-th percentile	1988
Maximum	2018
Range	107
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	19.0618194
Coefficient of variation (CV)	0.009748235641
Kurtosis	-0.4784724193
Mean	1955.412251
Median Absolute Deviation (MAD)	13
Skewness	0.4118138292
Sum	52735513
Variance	363.3529588

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1944	2778	10.3%
1943	1549	5.7%
1945	1149	4.3%
1941	817	3.0%
1942	711	2.6%
1928	598	2.2%
1969	570	2.1%
1968	551	2.0%
1974	468	1.7%
1940	456	1.7%
Other values (94)	17322	64.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1911	1	< 0.1%
1913	2	< 0.1%
1916	1	< 0.1%
1918	46	0.2%
1919	182	0.7%

Value	Count	Frequency (%)
2018	3	< 0.1%
2017	3	< 0.1%
2016	5	< 0.1%
2015	13	< 0.1%
2014	9	< 0.1%

Location
Categorical

HIGH CARDINALITY

Distinct count	12845
Unique (%)	47.6%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Atlantic Ocean All World	138
Pacific Ocean All World	132
Russia All Russia	102
North Sea All World	62
Mediterranean Sea All World	48
Other values (12840)	26487

Common Values
Length

Value	Count	Frequency (%)
Atlantic Ocean All World	138	0.5%
Pacific Ocean All World	132	0.5%
Russia All Russia	102	0.4%
North Sea All World	62	0.2%
Mediterranean Sea All World	48	0.2%
Mexico All Mexico	41	0.2%
Croydon Surrey	38	0.1%
United Kingdom All United Kingdom	37	0.1%
Fort Lauderdale-Hollywood Florida	37	0.1%
Kunming Yunnan	37	0.1%
Other values (12835)	26297	97.5%

Length

Max length	92
Median length	23
Mean length	24.99080426
Min length	7

Country
Categorical

HIGH CARDINALITY

Distinct count	218
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

United States of America	6337
United Kingdom	2167
Russia	1440
Canada	1314
France	811
Other values (213)	14900

Common Values
Length

Value	Count	Frequency (%)
United States of America	6337	23.5%
United Kingdom	2167	8.0%
Russia	1440	5.3%
Canada	1314	4.9%
France	811	3.0%
Brazil	717	2.7%
Australia	597	2.2%
World	597	2.2%
Germany	584	2.2%
Colombia	513	1.9%
Other values (208)	11892	44.1%

Length

Max length	30
Median length	8
Mean length	11.93755794
Min length	4

Region
Categorical

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

North America	7666
Europe	6236
Asia	5497
South America	2456
Africa	1984
Other values (4)	3130

Common Values
Length

Value	Count	Frequency (%)
North America	7666	28.4%
Europe	6236	23.1%
Asia	5497	20.4%
South America	2456	9.1%
Africa	1984	7.4%
Oceania	1276	4.7%
Central America	1200	4.4%
World	598	2.2%
Antarctica	56	0.2%

Length

Max length	15
Median length	6
Mean length	8.653491045
Min length	4

Crew on board
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct count	29
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.1318550928844227
Minimum	0
Maximum	1920
Zeros	3480
Zeros (%)	12.9%
Memory size	210.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	9
Maximum	1920
Range	1920
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	12.03736754
Coefficient of variation (CV)	3.843526339
Kurtosis	23847.36687
Mean	3.131855093
Median Absolute Deviation (MAD)	1
Skewness	149.7973589
Sum	84463
Variance	144.8982173

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	5962	22.1%
2	5496	20.4%
0	3480	12.9%
3	3100	11.5%
4	2649	9.8%
5	1875	7.0%
6	1341	5.0%
7	964	3.6%
8	654	2.4%
9	379	1.4%
Other values (19)	1069	4.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3480	12.9%
1	5962	22.1%
2	5496	20.4%
3	3100	11.5%
4	2649	9.8%

Value	Count	Frequency (%)
1920	1	< 0.1%
107	1	< 0.1%
48	1	< 0.1%
37	1	< 0.1%
25	1	< 0.1%

Crew fatalities
Real number (ℝ_≥0)

ZEROS

Distinct count	25
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.6889391523601172
Minimum	0
Maximum	25
Zeros	13596
Zeros (%)	50.4%
Memory size	210.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	7
Maximum	25
Range	25
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.545561619
Coefficient of variation (CV)	1.507195576
Kurtosis	5.704845242
Mean	1.688939152
Median Absolute Deviation (MAD)	0
Skewness	2.115337858
Sum	45549
Variance	6.479883957

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	13596	50.4%
1	3743	13.9%
2	2822	10.5%
3	1825	6.8%
4	1567	5.8%
5	1068	4.0%
6	695	2.6%
7	515	1.9%
8	364	1.3%
9	246	0.9%
Other values (15)	528	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13596	50.4%
1	3743	13.9%
2	2822	10.5%
3	1825	6.8%
4	1567	5.8%

Value	Count	Frequency (%)
25	1	< 0.1%
23	3	< 0.1%
22	1	< 0.1%
21	2	< 0.1%
20	1	< 0.1%

Pax on board
Real number (ℝ_≥0)

ZEROS

Distinct count	254
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.988987355853016
Minimum	0
Maximum	509
Zeros	14091
Zeros (%)	52.2%
Memory size	210.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	6
95-th percentile	45
Maximum	509
Range	509
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	26.27983587
Coefficient of variation (CV)	2.92355911
Kurtosis	49.39493322
Mean	8.988987356
Median Absolute Deviation (MAD)	0
Skewness	5.954956288
Sum	242424
Variance	690.6297734

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	14091	52.2%
1	1903	7.1%
2	1436	5.3%
3	1074	4.0%
4	919	3.4%
5	779	2.9%
6	556	2.1%
7	490	1.8%
8	453	1.7%
9	374	1.4%
Other values (244)	4894	18.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	14091	52.2%
1	1903	7.1%
2	1436	5.3%
3	1074	4.0%
4	919	3.4%

Value	Count	Frequency (%)
509	1	< 0.1%
451	1	< 0.1%
384	1	< 0.1%
381	1	< 0.1%
380	1	< 0.1%

Pax fatalities
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	181
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.3811413103934145
Minimum	0
Maximum	506
Zeros	20401
Zeros (%)	75.6%
Memory size	210.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	17
Maximum	506
Range	506
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	14.72485116
Coefficient of variation (CV)	4.354994309
Kurtosis	165.6564741
Mean	3.38114131
Median Absolute Deviation (MAD)	0
Skewness	10.36162094
Sum	91186
Variance	216.8212418

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	20401	75.6%
1	1261	4.7%
2	822	3.0%
3	575	2.1%
4	511	1.9%
5	374	1.4%
6	272	1.0%
7	234	0.9%
8	215	0.8%
9	171	0.6%
Other values (171)	2133	7.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	20401	75.6%
1	1261	4.7%
2	822	3.0%
3	575	2.1%
4	511	1.9%

Value	Count	Frequency (%)
506	1	< 0.1%
334	1	< 0.1%
326	1	< 0.1%
307	1	< 0.1%
289	1	< 0.1%

Other fatalities
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct count	40
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.09781601097556454
Minimum	0
Maximum	237
Zeros	26634
Zeros (%)	98.8%
Memory size	210.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	237
Range	237
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.412807292
Coefficient of variation (CV)	24.66679297
Kurtosis	4989.150825
Mean	0.09781601098
Median Absolute Deviation (MAD)	0
Skewness	61.95186755
Sum	2638
Variance	5.82163903

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	26634	98.8%
1	117	0.4%
2	48	0.2%
3	37	0.1%
4	26	0.1%
5	15	0.1%
6	13	< 0.1%
7	10	< 0.1%
10	8	< 0.1%
8	7	< 0.1%
Other values (30)	54	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	26634	98.8%
1	117	0.4%
2	48	0.2%
3	37	0.1%
4	26	0.1%

Value	Count	Frequency (%)
237	1	< 0.1%
180	1	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
71	1	< 0.1%

Total fatalities
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	201
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.806703993473989
Minimum	0
Maximum	520
Zeros	11108
Zeros (%)	41.2%
Memory size	210.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	5
95-th percentile	24
Maximum	520
Range	520
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	17.10951531
Coefficient of variation (CV)	2.946510677
Kurtosis	117.8017019
Mean	5.806703993
Median Absolute Deviation (MAD)	1
Skewness	8.755873054
Sum	156601
Variance	292.7355142

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	11108	41.2%
1	2658	9.9%
2	2458	9.1%
3	1775	6.6%
4	1566	5.8%
5	1263	4.7%
6	926	3.4%
7	746	2.8%
8	578	2.1%
9	439	1.6%
Other values (191)	3452	12.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11108	41.2%
1	2658	9.9%
2	2458	9.1%
3	1775	6.6%
4	1566	5.8%

Value	Count	Frequency (%)
520	1	< 0.1%
346	1	< 0.1%
335	1	< 0.1%
329	1	< 0.1%
312	1	< 0.1%

Circumstances
Categorical

HIGH CARDINALITY

Distinct count	21207
Unique (%)	78.7%
Missing	31
Missing (%)	0.1%
Memory size	210.7 KiB

Engine failure.	546
Crashed in unknown circumstances.	214
Shot down by enemy fire.	187
Crash on a mountain 8 minutes after takeoff from Nausori Airport. All 17 occupants were killed.	180
Crashed in unknown circumstances in the Gulf of Mexico while completing a training mission. All three crew members, two pilots and an instructor, were killed. Crew: Cpt John Krafft, 1st Lt Ronald Pahl, Ltjg Robert Roch.	157
Other values (21202)	25654

Common Values
Length

Value	Count	Frequency (%)
Engine failure.	546	2.0%
Crashed in unknown circumstances.	214	0.8%
Shot down by enemy fire.	187	0.7%
Crash on a mountain 8 minutes after takeoff from Nausori Airport. All 17 occupants were killed.	180	0.7%
Crashed in unknown circumstances in the Gulf of Mexico while completing a training mission. All three crew members, two pilots and an instructor, were killed. Crew: Cpt John Krafft, 1st Lt Ronald Pahl, Ltjg Robert Roch.	157	0.6%
Fuel exhaustion.	147	0.5%
While flying off Florida coast, the pilot informed the controllers that he was low fuel and he ditched the aircraft 300 meters off shore. The board said that the fuel quantity on board was insufficient for the trip.	123	0.5%
Controlled flight into terrain.	120	0.4%
Shot down by the German Flak.	116	0.4%
It appears that the thrust reverser on left engine was engaged by mistake on approach. This was caused by a mechanical failure.	113	0.4%
Other values (21197)	25035	92.8%

Length

Max length	12209
Median length	197
Mean length	278.6239386
Min length	3

FlightDate
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	17590
Unique (%)	65.2%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

1944-06-06	23
1943-05-17	17
1939-12-18	16
1945-03-24	16
1944-06-13	14
Other values (17585)	26883

Common Values
Length

Value	Count	Frequency (%)
1944-06-06	23	0.1%
1943-05-17	17	0.1%
1939-12-18	16	0.1%
1945-03-24	16	0.1%
1944-06-13	14	0.1%
1944-03-06	11	< 0.1%
1944-09-17	11	< 0.1%
1935-12-31	10	< 0.1%
1944-05-25	10	< 0.1%
1943-07-11	10	< 0.1%
Other values (17580)	26831	99.5%

Length

Max length	10
Median length	10
Mean length	10
Min length	10

FlightOperator
Categorical

HIGH CARDINALITY

Distinct count	7836
Unique (%)	29.1%
Missing	0
Missing (%)	0.0%
Memory size	210.7 KiB

Royal Air Force - RAF	2247
United States Air Force - USAF (since 1947)	1443
Aeroflot - Russian International Airlines	1358
United States Army Air Forces - USAAF (1941-1947)	1350
United States Navy - USN	651
Other values (7831)	19920

Common Values
Length

Value	Count	Frequency (%)
Royal Air Force - RAF	2247	8.3%
United States Air Force - USAF (since 1947)	1443	5.4%
Aeroflot - Russian International Airlines	1358	5.0%
United States Army Air Forces - USAAF (1941-1947)	1350	5.0%
United States Navy - USN	651	2.4%
Private American	403	1.5%
Royal Australian Air Force - RAAF	267	1.0%
French Air Force - Armée de l'Air	191	0.7%
Royal Canadian Air Force - RCAF	175	0.6%
Brazilian Air Force - Força Aérea Brasileira	164	0.6%
Other values (7826)	18720	69.4%

Length

Max length	90
Median length	24
Mean length	28.07504913
Min length	3

PlaneAge
Real number (ℝ_≥0)

ZEROS

Distinct count	80
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.84953094293448
Minimum	0
Maximum	90
Zeros	1979
Zeros (%)	7.3%
Memory size	210.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	8
Q3	18
95-th percentile	36
Maximum	90
Range	90
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	11.94262431
Coefficient of variation (CV)	1.007856291
Kurtosis	2.260631843
Mean	11.84953094
Median Absolute Deviation (MAD)	7
Skewness	1.441895748
Sum	319570
Variance	142.6262755

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	2850	10.6%
2	2029	7.5%
0	1979	7.3%
3	1485	5.5%
4	1328	4.9%
5	1271	4.7%
6	1162	4.3%
7	1057	3.9%
8	962	3.6%
9	800	3.0%
Other values (70)	12046	44.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1979	7.3%
1	2850	10.6%
2	2029	7.5%
3	1485	5.5%
4	1328	4.9%

Value	Count	Frequency (%)
90	1	< 0.1%
79	1	< 0.1%
78	2	< 0.1%
77	1	< 0.1%
75	4	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	rowid	src_rowid	dt	Date & Time	Type of aircraft	Operator	Registration	Flight Phase	Flight Type	Survivors	Site	Schedule	MSN	YOM	Location	Country	Region	Crew on board	Crew fatalities	Pax on board	Pax fatalities	Other fatalities	Total fatalities	Circumstances	FlightDate	FlightOperator	PlaneAge
0	1	1	2020-09-20 14:38:01.180000	Jul 15, 2020 at 2245 LT	Beechcraft 350 Super King Air	Turkish Police - Türk Polis (45115)	EM-809	Flight	Survey / Patrol / Reconnaissance	No	Mountains	Van - Van	FL-896	2015	Mt Artos\n\nEastern Anatolia Region (Dogu Anadolu Bölgesi)	Turkey	Asia	2	2	5	5	0	7	The twin engine aircraft departed Van-Ferit Melen Airport at 1834LT on a survey/reconnaissance mission over the province of Hakkari and Van, carrying five passengers and two pilots. At 2232LT, the crew informed ATC about his position vertical to Baskale on approach to Van-Ferit Melen Airport. Thirteen minutes later, the aircraft struck the slope of Mt Artos located 30 km southwest of runway 03 threshold. The aircraft was destroyed upon impact and all seven occupants were killed.	2020-07-15	Turkish Police - Türk Polis	5
1	2	2	2020-09-20 14:38:01.893000	Jul 14, 2020	De Havilland DHC-8-400 (Dash-8)	Bluebird Aviation (35301)	5Y-VVU	Landing (descent or approach)	Cargo	Yes	Airport (less than 10 km from airport)	Djibouti City – Beledweyne	4008	2000	Beledweyne-Haji-Sheikh Mahmud Hasan (Ugas Khalif)\n\nHiiraan (??????)	Somalia	Africa	3	0	0	0	0	0	After landing at Beledweyne-Haji-Sheikh Mahmud Hasan (Ugas Khalif) Airport, the aircraft went out of control and came to rest against several earth mounds, bursting into flames. All three crew members managed to escape while the aircraft was destroyed by fire. The crew was completing a cargo flight from Djibouti City on behalf of the African Union Mission to Somalia (AMISOM) and it is believed that the aircraft was carrying food supplies.	2020-07-14	Bluebird Aviation	20
2	3	3	2020-09-20 14:38:02.533000	Jul 13, 2020 at 0410 LT	PZL-Mielec AN-2	Zeus-Avia (45102)	RA-40851	Flight	Spraying (Agricultural)	No	Plain, Valley	Djibouti City – Beledweyne	1G174-47	1977	Kistenevo\n\nNizhny Novgorod oblast	Russia	Asia	2	2	0	0	0	2	The crew was completing a spraying mission near the village of Kistenovo (about 160 km southeast of Nizhny Novgorod). In unclear circumstances, it appears that the aircraft struck high tension wires then crashed in a field, bursting into flames. The captain was seriously injured while the copilot was killed. Two days later, the captain died from his injuries.	2020-07-13	Zeus-Avia	43
3	4	4	2020-09-20 14:38:03.197000	Jun 15, 2020	Gulfstream GII	Private American (31833)	N27SL	Landing (descent or approach)	Illegal (smuggling)	Yes	Plain, Valley	Djibouti City – Beledweyne	84	1970	Machiques\n\nZulia	Venezuela	South America	2	1	0	0	0	1	The crew was engaged in an illegal trip and elected to land on a remote 'airstrip' located in the region of Machiques. The aircraft crash landed and came to rest, bursting into flames. One pilot was killed and the second was injured.	2020-06-15	Private American	50
4	5	5	2020-09-20 14:38:03.823000	Jun 14, 2020	Embraer EMB-121 Xingu	Oeste Veículos (44860)	PT-MBV	Takeoff (climb)	Private	No	Airport (less than 10 km from airport)	Tangará da Serra – Goiânia	121-053	1982	Tangará da Serra\n\nMato Grosso	Brazil	South America	2	2	0	0	0	2	Shortly after takeoff, while in initial climb, the twin engine aircraft went out of control, lost altitude and crashed in a cornfield. The aircraft disintegrated on impact and both pilots were killed.	2020-06-14	Oeste Veículos	38
5	6	6	2020-09-20 14:38:04.460000	Jun 7, 2020 at 0415 LT	Mitsubishi MU-2 Marquise	McNeely Charter Service (32666)	N44MX	Takeoff (climb)	Cargo	No	Airport (less than 10 km from airport)	Everett – Huron	1526	1981	Sioux Falls\n\nSouth Dakota	United States of America	North America	1	1	0	0	0	1	The pilot departed Everett-Payne Field in the evening of June 6 on a cargo service to Huron, SD. En route, he was informed about the presence of thunderstorms in the Huron area and decided to divert to Sioux Falls Airport where he landed at 0140LT. Awaiting weather improvement, he left Sioux Falls around 0415LT to resume his flight to Huron. Upon takeoff, the twin engine aircraft crashed in unknown circumstances and was destroyed. The pilot was killed.	2020-06-07	McNeely Charter Service	39
6	7	7	2020-09-20 14:38:05.067000	Jun 5, 2020 at 1513 LT	Piper PA-31 Cheyenne	Larry Ray Pruitt (44800)	N135VE	Flight	Private	No	Plain, Valley	Williston – New Castle	31-7520024	1975	Eatonton\n\nGeorgia	United States of America	North America	1	1	4	4	0	5	The twin engine aircraft departed Willison Airport, Florida, at 1401LT bound for New Castle, Indiana, with four passengers and one pilot on board. Almost an hour into the flight, while cruising at an altitude of 25,000 feet, the aircraft entered a right turn then control was lost. While descending, the aircraft lost several pieces (wing parts) and caught fire before crashing in a wooded area located 6 miles northeast of Eatonton, bursting into flames. All five occupants were killed. They were on their way to funeral in Indiana.	2020-06-05	Larry Ray Pruitt	45
7	8	8	2020-09-20 14:38:05.670000	May 28, 2020 at 1543 LT	Rockwell Shrike Commander 500S	Alaska Department of Natural Resources (Division of Forestry) (41149)	N909AK	Takeoff (climb)	Survey / Patrol / Reconnaissance	Yes	Lake, Sea, Ocean, River	Aniak - Aniak	500-3232	1975	Aniak\n\nAlaska	United States of America	North America	1	0	3	0	0	0	After takeoff from Aniak Airport runway 10, the pilot encountered engine problems. Control was lost and the aircraft crashed in the Aniak River east of the airport. All four occupants were quickly rescued and medevaced to Anchorage. The aircraft was destroyed.	2020-05-28	Alaska Department of Natural Resources (Division of Forestry)	45
8	9	9	2020-09-20 14:38:06.313000	May 22, 2020 at 1439 LT	Airbus A320	Pakistan International Airlines - PIA (31061)	AP-BLD	Landing (descent or approach)	Scheduled Revenue Flight	Yes	City	Lahore - Karachi	2274	2004	Karachi-Muhammad Ali Jinnah-Quaid-e-Azam\n\nSindh (??? ????)	Pakistan	Asia	8	8	91	89	1	98	On 22 May 2020 at 13:05 hrs PST, the Pakistan International Airlines aircraft Airbus A320-214, registration number AP-BLD, took off from Lahore (Allama Iqbal International Airport – AIIAP) Pakistan to perform a regular commercial passenger flight (PK8303) to Karachi (Jinnah International Airport – JIAP) Pakistan, with 8 crew members (01 Captain, 01 First Officer, and 06 flight attendants) and 91 passengers on board. At 14:35 hrs the aircraft performed an ILS approach for runway 25L and touched down without landing gears, resting on the engines. Both engines scrubbed the runway at high speed. Flight crew initiated a go-around and informed “Karachi Approach” that they intend to make a second approach. About four minutes later, during downwind leg, at an altitude of around 2000 ft, flight crew declared an emergency and stated that both engines had failed. The aircraft started losing altitude. It crashed in a populated area, short of runway 25L by about 1340 meters. An immediate subsequent post impact fire initiated. Out of 99 souls on-board, 97 were fatally injured and 02 passengers survived. On ground 04 persons were injured however 01 out of these reportedly expired later at a hospital.\n\r\nBelow, the preliminary report published by the Pakistan AAIB.	2020-05-22	Pakistan International Airlines - PIA	16
9	10	10	2020-09-20 14:38:06.920000	May 12, 2020	Quest Kodiak 100	Missionary Aviation Fellowship - MAF (31410)	PK-MEC	Takeoff (climb)	Cargo	No	Lake, Sea, Ocean, River	Jayapura - Mamit	100-0026	2009	Jayapura-Sentani\n\nSpecial Region of Papua	Indonesia	Asia	1	1	0	0	0	1	Shortly after takeoff from Jayapura-Sentani Airport, while climbing, the pilot sent a brief mayday message when he lost control of the airplane that crashed in Sentani Lake, two minutes after takeoff. The wreckage was found at a depth of 13 meters and the pilot, sole on board, was killed.	2020-05-12	Missionary Aviation Fellowship - MAF	11

Last rows

	rowid	src_rowid	dt	Date & Time	Type of aircraft	Operator	Registration	Flight Phase	Flight Type	Survivors	Site	Schedule	MSN	YOM	Location	Country	Region	Crew on board	Crew fatalities	Total fatalities	Circumstances	FlightDate	FlightOperator
26959	26961	26961	2020-09-20 23:43:40.330000	Dec 8, 1918 at 1200 LT	De Havilland DH.4	United States Signal Corps - USSC (1914-1919) (39326)	97	Flight	Military	No	Plain, Valley	Seaton Carew AFB - Seaton Carew AFB	B9983	1918	Brookeville\n\nMaryland	United States of America	North America	1	0	0	Pilot was performing a mail flight. He was killed in the accident which occurred in unknown circumstances.	1918-12-08	United States Signal Corps - USSC (1914-1919)
26960	26962	26962	2020-09-20 23:43:41.223000	Dec 2, 1918 at 1200 LT	De Havilland DH.4	United States Signal Corps - USSC (1914-1919) (39326)	AS-22846	Flight	Military	No	Airport (less than 10 km from airport)	Seaton Carew AFB - Seaton Carew AFB	B9983	1918	Wright-Patterson AFB (Dayton)\n\nOhio	United States of America	North America	0	0	0	The accident occurred in unknown circumstances.	1918-12-02	United States Signal Corps - USSC (1914-1919)
26961	26963	26963	2020-09-20 23:43:42.223000	Nov 20, 1918 at 1200 LT	De Havilland DH.4	United States Signal Corps - USSC (1914-1919) (39326)	AS-39406	Flight	Military	No	Plain, Valley	Seaton Carew AFB - Seaton Carew AFB	B9983	1918	New Jersey\n\nNew Jersey	United States of America	North America	0	0	0	The accident occurred in unknown circumstances.	1918-11-20	United States Signal Corps - USSC (1914-1919)
26962	26964	26964	2020-09-20 23:43:43.420000	Nov 12, 1918 at 1200 LT	De Havilland DH.4	United States Signal Corps - USSC (1914-1919) (39326)	SC-39168	Flight	Military	No	Airport (less than 10 km from airport)	Seaton Carew AFB - Seaton Carew AFB	B9983	1918	Fort Worth\n\nTexas	United States of America	North America	0	0	0	The aircraft crashed in unknow circumstances near Everman-Barron Field airport.	1918-11-12	United States Signal Corps - USSC (1914-1919)
26963	26965	26965	2020-09-20 23:43:44.467000	Nov 12, 1918 at 1200 LT	De Havilland DH.4	United States Signal Corps - USSC (1914-1919) (39326)	SC-39168	Flight	Military	No	Airport (less than 10 km from airport)	Seaton Carew AFB - Seaton Carew AFB	B9983	1918	Detroit\n\nMichigan	United States of America	North America	0	0	0	The aircraft crashed in unknow circumstances near Everman-Barron Field airport.	1918-11-12	United States Signal Corps - USSC (1914-1919)
26964	26966	26966	2020-09-20 23:43:45.590000	Nov 9, 1918 at 1200 LT	De Havilland DH.4	United States Signal Corps - USSC (1914-1919) (39326)	AS-23130	Flight	Military	No	Airport (less than 10 km from airport)	Seaton Carew AFB - Seaton Carew AFB	B9983	1918	Langley AFB (Hampton)\n\nVirginia	United States of America	North America	0	0	0	The aircraft crashed in unknown circumstances.	1918-11-09	United States Signal Corps - USSC (1914-1919)
26965	26967	26967	2020-09-20 23:43:46.667000	Sep 13, 1918 at 1200 LT	De Havilland DH.9	Royal Air Force - RAF (31257)	D1745	Flight	Military	Yes	Plain, Valley	Seaton Carew AFB - Seaton Carew AFB	B9983	1918	United Kingdom\n\nAll United Kingdom	United Kingdom	Europe	1	0	0	The pilot tried to return to his base but due to low visibility by night, he lost his orientation. He elected to make an emergency landing in an open field but the aircraft hit a tree and crashed. The pilot was injured.	1918-09-13	Royal Air Force - RAF
26966	26968	26968	2020-09-20 23:43:47.813000	Aug 26, 1918	Blackburn RT.1 Kangaroo	Royal Air Force - RAF (31257)	B9976	Landing (descent or approach)	Military	Yes	Airport (less than 10 km from airport)	Seaton Carew AFB - Seaton Carew AFB	B9976	1918	Seaton Carew AFB\n\nDurham	United Kingdom	Europe	2	0	0	On final approach in bad visibility, aircraft was too low. It struck the ground short of runway and crashed. Both occupants were injured. Crew was performing a training flight on behalf of the 246th Squadron.	1918-08-26	Royal Air Force - RAF
26967	26969	26969	2020-09-20 23:43:48.787000	Jun 24, 1918 at 1200 LT	Breguet 14	French Air Force - Armée de l'Air (31256)	AS-4130	Landing (descent or approach)	Military	Yes	Airport (less than 10 km from airport)	Seaton Carew AFB - Seaton Carew AFB	B9976	1918	France\n\nAll France	France	Europe	2	0	0	The aircraft crashed in unknown circumstances.	1918-06-24	French Air Force - Armée de l'Air
26968	26970	26970	2020-09-20 23:43:49.800000	Jun 19, 1918	De Havilland DH.4	United States Signal Corps - USSC (1914-1919) (39326)	AS-32098	Flight	Military	No	Airport (less than 10 km from airport)	Wright Patterson AFB-Wright Patterson AFB	B9976	1918	Wright-Patterson AFB (Dayton)\n\nOhio	United States of America	North America	1	1	1	Lt. Frank Stuart Patterson, son and nephew of the co-founders of National Cash Register, is killed in the crash of his DH.4M, AS-32098, at Wilbur Wright Field during a flight test of a new mechanism for synchronizing machine gun and propeller, when a tie rod breaks during a dive from 15,000 feet (4,600 m), causing the wings to separate from the aircraft. Wishing to recognize the contributions of the Patterson family (owners of NCR) the area of Wright Field east of Huffman Dam (including Wilbur Wright Field, Fairfield Air Depot, and the Huffman Prairie) is renamed Patterson Field on 6 July 1931, in honor of Lt. Patterson.	1918-06-19	United States Signal Corps - USSC (1914-1919)

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows